
CREATE TABLE bookmarks ( bookmark_id INT, name varchar(50), uuid VARCHAR(255) NOT NULL, descr VARCHAR (255),time_updated timestamp, PRIMARY KEY (bookmark_id));

CREATE TABLE bookmark_tags (id INT, bookmark_id INT, tag_id INT, PRIMARY KEY (id));

CREATE TABLE tags (tag_id INT,name varchar(50), PRIMARY KEY (tag_id));

CREATE INDEX bookmark_tags_index ON bookmark_tags (bookmark_id, tag_id);

CREATE INDEX tags_index  on tags INDEX (tag_text);



